﻿CREATE TABLE [dbo].[Groups] (
    [GroupID]   INT            IDENTITY (1, 1) NOT NULL,
    [GroupName] NVARCHAR (MAX) NOT NULL,
    [UnitID]    INT            NOT NULL,
    CONSTRAINT [PK_dbo.Groups] PRIMARY KEY CLUSTERED ([GroupID] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_UnitID]
    ON [dbo].[Groups]([UnitID] ASC);

